CREATE PROCEDURE coreAdminGroupsGetForUser
(
	@userid int
)
AS

SELECT DISTINCT g.PK_ID as PK_ID, g.GroupName as GroupName FROM AdministrationUserGroups aug
INNER JOIN AdministrationGroups g ON g.PK_ID = aug.FK_Group
WHERE aug.FK_User = @userid;
